<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

$q = $_GET["q"];
include '../../../readcookie.php';
include '../../../db.php';


$sbsql= "SELECT subevent_id, subevent_title FROM SubEvent WHERE subevent_mainevent = '" . $q . "'";
$result=mysql_query($sbsql);

while($row=mysql_fetch_array($result)){
    $id = $row['subevent_id'];
    $thing = $row['subevent_title'];
    $options.="<OPTION VALUE=\"$id\">" . $thing;
}

echo'
<form><select name="eventID" onchange="showSub(this.value)">
<OPTION VALUE=0>Select Subevent...',$options,'</select>
</form><br />
<div id="txtHint3"><b>
</b></div>';


?>
